██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀                                     
    

Sets - Execution started 30/01/2023 05:06 UTC
By Guilherme Ruiz

---

Table of Contents

• 1  Data aquisition
  • 1.1  Fetch set lists
  • 1.2  Fetch set properties
  • 1.3  Merge data
  • 1.4  Save data
• 3  Check changes
  • 3.1  Load previous data
  • 3.2  Generate changelog
• 4  Data visualization
  • 4.1  Full data
  • 4.2  Set
  • 4.3  Card number
  • 4.4  Name
  • 4.5  Rarity
    • 4.5.1  By unique
    • 4.5.2  By combination
  • 4.6  Print
  • 4.7  Quantity
  • 4.8  Region
  • 4.9  Cover card
  • 4.10  Series
  • 4.11  Set type
  • 4.12  Release
    • 4.12.1  By year
    • 4.12.2  By month
    • 4.12.3  By day
    • 4.12.4  By region
    • 4.12.5  By series
    • 4.12.6  By set type
• 5  Debug
  • 5.1  Has nan name/number
  • 5.2  Has nan rarity
  • 5.3  Has quantity as print
  • 5.4  Has nan release
  • 5.5  Has print as rarity
  • 5.6  Merge failed
• 6  Epilogue
  • 6.1  HTML export

Data aquisition

Fetch set lists

  0%|          | 0/80 [00:00<?, ?it/s]

4120 set lists received - 76 errors

Fetch set properties

  0%|          | 0/96 [00:00<?, ?it/s]

1430 set properties received - 3 errors

Merge data

Set properties merged

Save data

Data saved

Check changes

Load previous data

File loaded

Generate changelog

	Name	Rarity	Print	Version
Card number
CL03-SC174	<NA>	NaN	<NA>	Old
CL03-SC174	Scrap Factory	(Common,)	New	New

Changelog saved

Data visualization

Full data

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
0	2013 Collectible Tins Wave 1	CT10-PT001	Tidal, Dragon Ruler of Waterfalls	(Secret Rare,)	<NA>	<NA>	PT	2013-08-30	<NA>	Collectible tin	(Blaster, Dragon Ruler of Infernos, Tidal, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:55:52	both
1	2013 Collectible Tins Wave 1	CT10-PT005	Black Luster Soldier - Envoy of the Beginning	(Super Rare,)	<NA>	<NA>	PT	2013-08-30	<NA>	Collectible tin	(Blaster, Dragon Ruler of Infernos, Tidal, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:55:52	both
2	2013 Collectible Tins Wave 1	CT10-PT006	Ally of Justice Catastor	(Super Rare,)	<NA>	<NA>	PT	2013-08-30	<NA>	Collectible tin	(Blaster, Dragon Ruler of Infernos, Tidal, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:55:52	both
3	2013 Collectible Tins Wave 1	CT10-PT007	Superdreadnought Rail Cannon Gustav Max	(Super Rare,)	<NA>	<NA>	PT	2013-08-30	<NA>	Collectible tin	(Blaster, Dragon Ruler of Infernos, Tidal, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:55:52	both
4	2013 Collectible Tins Wave 1	CT10-PT002	Blaster, Dragon Ruler of Infernos	(Secret Rare,)	<NA>	<NA>	PT	2013-08-30	<NA>	Collectible tin	(Blaster, Dragon Ruler of Infernos, Tidal, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:55:52	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
156159	Jump Festa 2004 promotional cards	PC3-007	Bazoo the Soul-Eater	(Common, Normal Parallel Rare)	<NA>	<NA>	JP	2003-12-20	<NA>	Tournament prize card	NaN	https://yugipedia.com/wiki/Jump_Festa_2004_pro...	2022-11-06 04:44:51	both
156160	Jump Festa 2005 promotional cards	PC5-JP007	Dark Balter the Terrible	(Common, Normal Parallel Rare)	<NA>	<NA>	JP	2004-12-18	<NA>	Promotional card	NaN	https://yugipedia.com/wiki/Jump_Festa_2005_pro...	2022-11-06 05:15:26	both
156161	Jump Festa 2005 promotional cards	PC5-JP008	Ryu Senshi	(Common, Normal Parallel Rare)	<NA>	<NA>	JP	2004-12-18	<NA>	Promotional card	NaN	https://yugipedia.com/wiki/Jump_Festa_2005_pro...	2022-11-06 05:15:26	both
156162	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Academia_Disk	2022-12-28 20:46:20	right_only
156163	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Structure_Deck:_Mar...	2014-07-03 18:52:14	right_only

156164 rows × 14 columns

Full data available here

Set

Total number of sets: 1435

	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Set
"Amabie-San" Present Campaign	2	1	1	0	0	1	1	0	1	0	1	1	1
"Blue-Eyes White Dragon Rush Rare Special Red Version" GET Campaign	2	1	1	0	0	2	2	0	1	0	1	1	1
"Blue-Eyes White Dragon Secret Rare Special Blue Version" GET Campaign	1	1	1	0	0	1	1	0	1	0	1	1	1
"Blue-Eyes White Dragon" 20th Anniversary Gold Edition	0	1	1	0	0	1	1	0	1	0	1	1	1
"Blue-Eyes White Dragon" 20th Anniversary Silver Edition	0	1	1	0	0	1	1	0	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Yu-Gi-Oh! ZEXAL World Duel Carnival Duel Champion Guide! promotional card	1	1	1	0	0	1	1	0	1	0	1	1	1
Yu-Gi-Oh! ZEXAL World Duel Carnival promotional cards	18	3	1	0	0	6	2	0	1	0	1	1	1
Yugi's Legendary Decks	650	112	3	0	0	5	2	0	1	0	1	1	1
Zexal Collection Tin	120	24	3	0	0	5	1	0	1	1	1	1	1
Zombie World Structure Deck	185	37	2	0	2	5	1	0	1	1	1	1	1

1435 rows × 13 columns

	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
count	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.0
mean	107.213240	27.548432	2.446690	0.357491	0.096864	2.696864	1.455052	0.390941	0.953310	0.310801	0.994425	0.994425	1.0
std	236.084401	45.357186	2.316437	0.818887	0.446227	2.298980	0.997155	0.488131	0.211047	0.462983	0.074483	0.074483	0.0
min	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.0
25%	1.000000	1.000000	1.000000	0.000000	0.000000	1.000000	1.000000	0.000000	1.000000	0.000000	1.000000	1.000000	1.0
50%	10.000000	5.000000	1.000000	0.000000	0.000000	1.000000	1.000000	0.000000	1.000000	0.000000	1.000000	1.000000	1.0
75%	86.000000	41.000000	3.000000	0.000000	0.000000	5.000000	2.000000	1.000000	1.000000	1.000000	1.000000	1.000000	1.0
max	1652.000000	307.000000	17.000000	6.000000	3.000000	10.000000	9.000000	1.000000	1.000000	1.000000	1.000000	1.000000	1.0

Card number

Total number of card numbers: 151985

	Set	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Card number
15AX-JP000	2	1	1	1	0	1	1	0	1	0	2	2	1
15AX-JPM01	1	1	1	1	0	1	1	0	1	0	1	1	1
15AX-JPM02	1	1	1	1	0	1	1	0	1	0	1	1	1
15AX-JPM03	1	1	1	1	0	1	1	0	1	0	1	1	1
15AX-JPM04	1	1	1	1	0	1	1	0	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
ZTIN-SP021	1	1	1	0	0	1	1	0	1	1	1	1	1
ZTIN-SPV01	1	1	1	0	0	1	1	0	1	1	1	1	1
ZTIN-SPV02	1	1	1	0	0	1	1	0	1	1	1	1	1
ZTIN-SPV03	1	1	1	0	0	1	1	0	1	1	1	1	1
<NA>	44	406	7	2	2	10	40	6	11	6	43	43	3

151986 rows × 13 columns

Name

Total number of card names: 12579

	Set	Card number	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Name
"A Legendary Ocean"	1	1	0	0	0	1	1	0	1	1	1	1	1
"A" Cell Breeding Device	4	9	1	1	0	7	6	1	2	3	4	4	1
"A" Cell Incubator	2	8	1	2	0	7	6	1	1	2	2	2	1
"A" Cell Recombination Device	1	8	1	0	0	8	4	1	1	1	1	1	1
"A" Cell Scatter Burst	3	9	1	1	0	7	6	1	1	3	3	3	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Zubaba Knight	12	50	5	1	1	8	23	2	2	7	12	12	1
Zubababancho Gagagacoat	1	2	1	1	0	2	2	1	1	1	1	1	1
Zure, Knight of Dark World	8	24	1	1	1	10	14	1	4	4	8	8	1
Zushin the Sleeping Giant	3	14	3	1	0	8	4	1	2	3	3	3	1
<NA>	9	174	3	0	0	9	12	4	4	4	9	9	2

12580 rows × 13 columns

	Set	Card number	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
count	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000
mean	3.142698	12.069878	2.073615	0.682407	0.107481	6.891645	5.983306	1.090548	1.473329	1.843469	3.131409	3.131409	1.010812
std	3.515891	11.605735	1.492543	0.676727	0.336553	2.558853	5.904568	0.788284	0.936945	1.841657	3.495264	3.495264	0.103420
min	1.000000	0.000000	0.000000	0.000000	0.000000	1.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.000000
25%	1.000000	7.000000	1.000000	0.000000	0.000000	6.000000	3.000000	1.000000	1.000000	1.000000	1.000000	1.000000	1.000000
50%	2.000000	9.000000	2.000000	1.000000	0.000000	8.000000	4.000000	1.000000	1.000000	1.000000	2.000000	2.000000	1.000000
75%	4.000000	14.000000	3.000000	1.000000	0.000000	8.000000	7.000000	1.000000	2.000000	2.000000	4.000000	4.000000	1.000000
max	80.000000	275.000000	28.000000	4.000000	3.000000	15.000000	122.000000	12.000000	16.000000	41.000000	80.000000	80.000000	2.000000

Rarity

Total number of rarities: 49

By unique

	Set	Card number	Name	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Rarity
10000 Secret Rare	2	7	1	1	0	7	2	1	1	2	2	2	1
20th Secret Rare	16	135	134	3	0	1	13	3	3	6	16	16	1
Collector's Rare	6	301	76	2	0	7	6	2	1	6	6	6	1
Collectors Rare	8	112	112	2	0	1	8	1	1	7	8	8	1
Common	562	76878	8592	6	3	16	927	26	23	268	560	560	2
Duel Terminal Normal Parallel Rare	38	1906	511	2	0	7	34	1	3	11	38	38	1
Duel Terminal Normal Rare Parallel Rare	5	15	15	0	0	1	5	0	1	4	5	5	1
Duel Terminal Rare Parallel Rare	34	368	141	2	0	2	31	0	1	10	34	34	1
Duel Terminal Secret Parallel Rare	16	103	55	1	0	1	16	0	1	10	16	16	1
Duel Terminal Super Parallel Rare	34	240	85	2	0	2	31	0	1	10	34	34	1
Duel Terminal Ultra Parallel Rare	42	371	87	2	0	7	33	1	5	18	42	42	1
Extra Secret Parallel Rare	3	10	6	0	0	2	4	0	2	1	3	3	1
Extra Secret Rare	24	77	50	1	1	3	31	3	5	17	24	24	1
Ghost Rare	35	255	47	3	0	6	63	1	2	34	35	35	1
Ghost/Gold Rare	1	30	6	0	0	5	2	1	1	0	1	1	1
Gold Rare	23	2057	363	2	0	9	39	3	5	0	23	23	1
Gold Rush Rare	2	16	16	2	0	1	2	0	1	1	2	2	1
Gold Secret Rare	8	644	154	2	0	9	17	1	3	0	8	8	1
Holographic Parallel Rare	2	2	2	1	0	1	2	0	1	0	2	2	1
Holographic Rare	68	123	65	2	0	6	121	3	2	65	68	68	1
Kaiba Corporation Common	10	10	10	0	0	1	8	0	1	0	10	10	1
Kaiba Corporation Rare	5	5	5	0	0	1	5	1	2	0	5	5	1
Kaiba Corporation Ultra Rare	3	3	3	0	0	1	3	0	2	0	3	3	1
Millennium Gold Rare	2	9	6	2	0	2	2	0	1	2	2	2	1
Millennium Rare	9	316	152	3	0	3	10	2	6	2	9	9	1
Millennium Secret Rare	1	4	2	1	0	2	0	0	1	1	1	1	1
Millennium Super Rare	1	40	20	1	0	2	0	0	1	1	1	1	1
Millennium Ultra Rare	1	16	8	1	0	2	0	0	1	1	1	1	1
Mosaic Rare	1	1290	215	0	0	6	2	0	1	1	1	1	1
Normal Parallel Rare	130	2068	994	4	1	4	162	7	10	61	130	130	1
Normal Rare	81	575	299	2	0	7	151	3	2	72	81	81	1
Over Rush Rare	1	1	1	0	0	1	1	1	1	1	1	1	1
Platinum Secret Rare	2	24	4	0	0	6	4	0	1	2	2	2	1
Prismatic Secret Rare	40	1393	369	3	0	11	48	6	4	15	40	40	1
Rare	256	18684	3526	7	2	14	552	13	8	177	255	255	2
Rush Rare	16	106	51	0	0	2	28	1	2	13	16	16	1
Secret Parallel Rare	2	12	6	1	0	2	4	0	1	0	2	2	1
Secret Rare	380	10361	2299	11	1	14	539	20	20	201	375	375	2
Shatterfoil Rare	4	1482	292	0	1	7	5	1	2	4	4	4	1
Short Print	56	1316	234	3	0	9	110	3	1	46	56	56	1
Starfoil Rare	6	2019	380	0	0	6	9	1	3	4	6	6	1
Starlight Rare	12	316	56	2	0	6	13	1	1	12	12	12	1
Super Parallel Rare	6	154	82	3	1	3	10	1	3	2	6	6	1
Super Rare	587	20266	3890	9	1	16	955	26	20	276	583	583	2
Super Short Print	1	35	5	1	0	7	0	1	1	1	1	1	1
Ultimate Rare	115	4315	847	2	1	10	278	5	6	85	114	114	2
Ultra Parallel Rare	67	279	170	3	1	7	63	4	7	20	66	66	2
Ultra Rare	794	17963	3178	7	2	16	1076	33	26	278	792	792	2
Ultra Secret Rare	3	0	8	0	0	1	3	1	3	0	3	3	1
NaN	15	377	206	0	0	4	12	3	2	3	14	14	3

By combination

	Set	Card number	Name	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Rarity
(10000 Secret Rare,)	2	7	1	1	0	7	2	1	1	2	2	2	1
(20th Secret Rare,)	9	25	24	1	0	1	8	2	3	1	9	9	1
(Common,)	523	70402	7920	5	3	16	855	24	22	245	521	521	2
(Common, Duel Terminal Normal Parallel Rare)	1	834	139	2	0	6	1	0	1	1	1	1	1
(Common, Gold Rare)	4	144	76	0	0	2	6	1	1	0	4	4	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
(Ultra Rare, Ultimate Rare, Ultra Parallel Rare)	1	1	1	0	0	1	1	1	1	1	1	1	1
(Ultra Rare, Ultra Parallel Rare)	22	71	67	0	0	1	16	3	2	16	21	21	2
(Ultra Rare, Ultra Parallel Rare, Ultimate Rare)	5	5	5	0	0	1	3	2	1	3	5	5	1
(Ultra Secret Rare,)	3	0	8	0	0	1	3	1	3	0	3	3	1
NaN	15	377	206	0	0	4	12	3	2	3	14	14	3

120 rows × 13 columns

Print

Total number of prints: 16

	Set	Card number	Name	Rarity	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Print
American debut	1	3	3	1	0	1	1	0	1	1	1	1	1
European & Oceanian debut	1	6	6	1	0	1	1	0	1	0	1	1	1
European debut	12	146	146	5	0	2	10	0	2	1	12	12	1
Functional errata	1	2	2	1	0	1	1	0	1	1	1	1	1
New	233	11759	3986	50	3	11	250	19	13	129	231	231	2
New art	1	4	2	1	0	2	2	0	1	1	1	1	1
New artwork	10	74	15	5	0	7	12	3	4	4	10	10	1
New artwork (renamed)	1	3	3	1	0	1	1	0	1	0	1	1	1
North American debut	2	4	4	2	0	2	2	0	2	0	2	2	1
Oceanian debut	1	1	1	1	0	1	1	0	1	0	1	1	1
Reprint	229	14033	4316	48	3	11	246	18	12	127	227	227	2
Reprint (New Art)	2	2	1	2	0	2	2	1	1	1	2	2	1
Reprint (functional errata)	15	33	21	10	0	8	14	3	3	5	15	15	1
Reprint (new artwork)	1	1	1	1	0	1	1	0	1	1	1	1	1
Reprint (renamed)	2	76	76	6	0	1	2	1	1	0	2	2	1
TCG legal debut	1	1	1	1	0	1	1	1	1	1	1	1	1
<NA>	1349	126014	11419	108	3	16	1447	42	37	315	1341	1341	3

Quantity

Total number of quantities: 3

	Set	Card number	Name	Rarity	Print	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Quantity
1	66	8760	1167	10	2	11	108	1	5	45	65	65	2
2	65	839	165	4	2	11	108	1	5	44	64	64	2
3	8	64	20	1	2	8	11	0	3	6	8	8	1
<NA>	1372	142334	12503	118	16	16	1502	45	36	316	1364	1364	3

Region

Total number of regions: 16

	Set	Card number	Name	Rarity	Print	Quantity	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Region
AE	34	1527	1493	12	0	2	31	2	7	19	34	34	1
AU	2	100	87	3	0	0	1	0	1	2	2	2	1
DE	455	20372	10393	45	4	3	381	12	18	219	454	454	2
EN	658	20184	10480	51	14	3	536	22	23	207	657	657	2
EU	25	543	456	8	3	0	16	2	9	6	25	25	1
FC	3	102	87	3	0	0	1	0	2	2	3	3	1
FR	448	19776	10380	46	4	3	375	14	18	219	447	447	2
IT	447	20051	10388	46	4	3	378	12	18	218	446	446	2
JA	3	185	185	8	0	0	3	2	2	3	3	3	1
JP	714	19087	11213	87	6	3	530	28	28	247	709	709	2
KR	383	15937	10755	55	4	3	333	16	15	224	378	378	2
NA	47	1526	1333	10	4	2	39	5	11	12	47	47	1
PT	204	12461	7823	40	4	3	165	8	10	120	204	204	1
SC	23	1237	1046	12	2	0	23	5	1	12	23	23	1
SP	417	19211	10285	45	4	3	356	9	17	205	416	416	2
TC	7	300	286	12	0	2	5	2	2	3	7	7	1
<NA>	2	0	0	0	0	0	0	0	0	0	2	2	1

	Set	Card number	Name	Rarity	Print	Quantity	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
count	17.000000	17.000000	17.000000	17.000000	17.000000	17.000000	17.000000	17.000000	17.000000	17.000000	17.000000	17.000000	17.000000
mean	227.764706	8976.411765	5099.411765	28.411765	3.117647	1.764706	186.647059	8.176471	10.705882	101.058824	226.882353	226.882353	1.411765
std	254.359620	9337.505656	5032.723443	25.040115	3.461978	1.393261	205.059120	8.225230	8.716111	106.359338	253.258238	253.258238	0.507300
min	2.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	2.000000	2.000000	1.000000
25%	7.000000	300.000000	286.000000	8.000000	0.000000	0.000000	5.000000	2.000000	2.000000	3.000000	7.000000	7.000000	1.000000
50%	47.000000	1527.000000	1493.000000	12.000000	4.000000	2.000000	39.000000	5.000000	10.000000	19.000000	47.000000	47.000000	1.000000
75%	447.000000	19211.000000	10388.000000	46.000000	4.000000	3.000000	375.000000	12.000000	18.000000	218.000000	446.000000	446.000000	2.000000
max	714.000000	20372.000000	11213.000000	87.000000	14.000000	3.000000	536.000000	28.000000	28.000000	247.000000	709.000000	709.000000	2.000000

Cover card

Total number of cover cards: 671

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Page URL	Modification date	_merge
Cover card
A-to-Z-Dragon Buster Cannon	1	352	54	4	2	2	8	4	0	1	1	1	1
Accel Synchro Stardust Dragon	1	100	50	3	2	0	2	2	0	1	1	1	1
Accesscode Talker	1	766	101	16	2	0	8	3	1	1	1	1	1
Adamancipator Risen - Dragite	1	135	45	3	2	0	3	3	0	1	1	1	1
Adreus, Keeper of Armageddon	1	84	42	4	0	0	2	2	0	1	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Yamiterasu the Divine Ruler	1	132	66	6	0	0	2	2	1	1	1	1	1
Yoko, the Graceful Mayakashi	2	450	60	4	2	0	8	3	0	1	2	2	1
Yubel - The Ultimate Nightmare	2	560	100	10	0	0	6	5	1	2	2	2	1
Z-Metal Tank	1	55	55	7	0	0	1	1	1	1	1	1	1
Zerrziel, Ruler of the Evil Eyed	1	90	45	3	2	0	2	2	0	1	1	1	1

671 rows × 13 columns

Series

Total number of series: 45

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Set type	Cover card	Page URL	Modification date	_merge
Series
+1 Bonus Pack	7	249	137	3	0	0	2	12	1	0	7	7	1
Animation Chronicle	2	200	100	7	2	0	2	4	1	2	2	2	1
Astral Pack	7	1110	184	4	4	0	6	16	1	0	7	7	1
Attribute Duelist Pack	4	429	199	6	3	0	3	9	1	4	4	4	1
Battle Pack (Rush Duel)	8	80	80	3	3	0	1	8	1	0	8	8	1
Booster (series)	4	181	176	7	2	0	1	4	1	2	4	4	1
Booster pack	1	50	50	3	0	0	1	1	1	0	1	1	1
Champion Pack	8	640	161	4	2	0	4	8	1	0	8	8	1
Classic Pack	3	570	423	9	2	0	1	3	1	2	3	3	1
Collectors Pack	8	794	374	12	3	0	3	16	1	8	8	8	1
Core Booster	88	49929	7471	38	2	0	13	296	1	80	88	88	1
Deck Build Pack	3	360	134	5	2	0	3	8	1	3	3	3	1
Deck Mod Pack	12	1447	756	8	0	0	2	23	1	12	12	12	1
Duelist Pack	21	3739	634	7	3	0	8	49	1	19	21	21	1
Entry Pack (series)	10	163	160	3	2	0	1	10	1	0	10	10	1
Expansion Pack	4	280	280	6	0	0	1	4	1	0	4	4	1
Gold Series (series)	8	2595	446	9	2	0	9	18	1	0	8	8	1
Hidden Arsenal (series)	7	2470	400	2	2	0	7	16	1	7	7	7	1
Hobby League	1	83	43	3	0	0	5	0	1	0	1	1	1
Jump Victory Carnival	1	1	1	1	0	0	1	1	1	0	1	1	1
Legend Duelist (series)	6	780	343	9	2	0	3	14	1	6	6	6	1
Legendary Collection (series)	2	57	19	1	2	0	3	4	1	0	2	2	1
Master Guide promotional cards (series)	4	8	8	1	0	0	1	4	1	0	4	4	1
Mattel Action Figure promotional cards	3	17	16	1	0	0	1	3	1	0	3	3	1
McDonald's Promotional Cards	2	35	35	4	3	0	2	2	1	0	2	2	1
Monster Figure Collection promotional cards	3	15	15	1	0	0	1	3	1	0	3	3	1
OTS Tournament Pack	2	324	54	4	0	0	6	3	1	0	2	2	1
Perfect Rulebook promotional cards	3	3	3	2	0	0	1	3	1	0	3	3	1
Pharaoh Tour promotional cards	3	20	5	2	0	0	4	3	1	0	3	3	1
Premium Pack	25	452	368	8	3	0	2	25	1	12	25	25	1
Shonen Jump promotional cards	78	85	81	2	0	0	2	44	1	0	78	78	1
Sneak Peek Participation Cards	57	302	61	2	0	0	8	69	1	0	57	57	1
Star Pack	3	900	149	4	0	0	6	6	1	3	3	3	1
Structure Deck R	3	248	122	4	2	2	2	6	1	3	3	3	1
The Valuable Book promotional cards	18	38	38	2	0	0	2	19	1	0	18	18	1
V Jump August 1999 Special Present	1	0	6	1	0	0	1	1	1	0	1	1	1
V Jump Edition (series)	4	16	16	3	0	0	1	4	1	0	4	4	1
V Jump promotional cards	78	94	98	6	0	0	1	74	1	0	78	78	1
Value Box	9	11	11	3	0	0	1	7	1	0	9	9	1
Yu-Gi-Oh! 5D's manga promotional cards	9	19	9	1	0	0	3	18	1	0	9	9	1
Yu-Gi-Oh! Day promotional cards	7	7	1	1	0	0	2	7	1	0	7	7	1
Yu-Gi-Oh! GX manga promotional cards	9	19	9	2	0	0	3	17	1	0	9	9	1
Yu-Gi-Oh! R promotional cards	4	8	4	2	0	0	2	8	1	0	4	4	1
Yu-Gi-Oh! World Championship prize cards	13	35	30	5	0	0	3	13	1	0	13	13	1
Yu-Gi-Oh! ZEXAL manga promotional cards	8	25	8	1	0	0	4	25	1	0	8	8	1

Set type

Total number of set types: 37

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Cover card	Page URL	Modification date	_merge
Set type
Beta set	1	535	106	1	0	2	5	1	0	0	1	1	1
Binder	2	6	6	2	2	0	1	2	0	0	2	2	1
Book promotional card	4	5	5	3	0	0	2	4	1	0	4	4	1
Book promotional cards	26	52	52	4	0	0	2	27	2	0	26	26	1
Booster pack	467	114012	11764	101	15	0	14	809	23	223	467	467	1
Boss Duel Deck	1	8	8	1	0	0	1	1	0	0	1	1	1
Bundle	9	11	11	3	0	0	1	7	1	0	9	9	1
Collectible tin	53	5901	1005	9	4	0	8	66	0	35	53	53	1
Collector's Set	11	6226	1102	7	2	3	7	14	0	6	11	11	1
Core Booster	1	160	80	6	0	0	2	2	0	1	1	1	1
Deluxe Edition	4	114	19	2	0	0	6	8	0	4	4	4	1
Demo Deck	4	380	64	1	0	0	7	8	0	1	4	4	1
Duel Disk	2	16	9	2	2	0	2	4	0	0	2	2	1
Duel Disk promotional cards	5	13	12	4	0	0	2	5	0	0	5	5	1
Duel Terminal	34	1847	706	6	2	0	2	31	0	10	34	34	1
Duelist League participation cards	10	60	16	3	0	0	9	9	0	0	10	10	1
Duelist Set	5	312	154	5	0	2	2	5	0	5	5	5	1
Enhancement Pack	2	20	20	1	0	0	1	1	0	0	2	2	1
Hobby League participation cards	40	83	43	3	0	0	5	38	0	0	40	40	1
Magazine promotional card	167	191	173	9	0	0	3	127	3	7	167	167	1
Magazine promotional cards	4	4	4	1	0	0	2	2	0	0	4	4	1
Main Deck	2	44	44	2	0	0	1	2	0	1	2	2	1
Manga promotional card	33	74	32	2	0	0	4	69	4	0	33	33	1
Participation card	60	485	119	6	0	0	9	71	2	0	60	60	1
Preconstructed Deck	6	401	223	10	3	0	2	8	0	4	6	6	1
Prize card	16	46	41	5	0	0	3	16	1	0	16	16	1
Prize cards	1	68	20	1	0	0	5	1	0	0	1	1	1
Promotional card	140	315	206	18	3	0	9	141	6	21	140	140	1
Promotional cards	25	200	62	8	2	0	10	34	1	1	25	25	1
Special Edition	90	1189	289	9	5	0	10	109	0	1	90	90	1
Starter Deck	38	6777	606	10	2	3	14	59	0	26	38	38	1
Structure Deck	64	9454	1206	8	2	3	10	117	1	45	64	64	1
Tournament prize card	1	2	2	1	0	0	1	1	0	0	1	1	1
Tournament promotional card	2	5	2	2	0	0	2	2	0	0	2	2	1
Vendor Edition	6	210	210	2	0	0	1	6	0	0	6	6	1
Video game promotional card	9	79	39	4	0	0	8	15	0	0	9	9	1
Video games promotional card	23	325	73	4	2	0	9	43	0	0	23	23	1

Release

Total number of release dates: 1573

	Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Set type	Cover card	Page URL	Modification date	_merge
Release
1999-03-01	1	0	40	2	2	0	1	1	1	0	1	1	1
1999-03-18	1	0	1	1	0	0	1	0	1	0	1	1	1
1999-04-29	1	0	1	1	0	0	1	0	1	0	1	1	1
1999-05-05	1	0	1	1	0	0	1	0	1	0	1	1	1
1999-05-25	1	0	40	2	0	0	1	1	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
2023-01-26	1	1	1	1	0	0	1	0	1	0	1	1	1
2023-02-25	1	190	43	5	2	0	1	1	1	0	1	1	1
2023-03-01	3	2	3	3	0	0	1	0	1	0	3	3	1
2023-05-01	3	3	3	1	0	0	1	0	1	0	3	3	1
NaT	119	3971	1085	23	4	2	13	9	13	14	111	111	3

1574 rows × 13 columns

By year

	Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Set type	Cover card	Page URL	_merge
Release
1999	18	0	353	28	10	2	15	8	15	1	18	15
2000	12	274	324	21	9	2	10	8	11	5	12	10
2001	12	305	307	30	4	4	12	4	11	6	12	12
2002	22	1369	1197	81	10	2	21	9	20	14	22	19
2003	51	2669	2263	123	12	0	52	12	41	29	51	38
2004	93	6502	4687	193	6	0	108	27	74	45	93	59
2005	75	7826	4043	160	27	18	127	28	64	37	75	49
2006	101	5241	3045	185	22	20	125	39	92	42	101	67
2007	126	5744	3344	272	16	18	192	53	115	54	126	94
2008	124	5979	3248	267	21	12	194	51	113	50	124	95
2009	117	5104	2973	278	6	14	172	40	111	54	117	93
2010	138	6093	3322	309	8	16	204	58	124	53	138	103
2011	144	6922	3952	318	16	18	214	55	133	53	144	105
2012	141	10271	5425	349	17	20	218	57	128	53	141	111
2013	146	8913	4469	341	18	24	222	68	129	69	146	108
2014	141	12625	5705	381	38	20	225	68	126	60	141	107
2015	136	10432	4828	353	33	12	221	69	125	57	136	103
2016	137	10356	4755	330	39	10	210	62	124	59	137	97
2017	67	8404	3324	198	27	6	140	29	64	35	67	54
2018	46	5413	2129	141	26	0	103	20	41	28	46	41
2019	50	6264	2670	162	29	0	101	17	45	25	50	43
2020	38	6435	2143	151	34	0	85	18	36	27	38	36
2021	65	6812	2733	241	46	6	91	38	53	36	65	49
2022	73	8953	3673	250	66	3	96	43	61	42	73	56
2023	15	798	352	42	7	0	15	7	9	4	15	9

By month

By day

By region

		Set	Card number	Name	Rarity	Print	Quantity	Series	Set type	Cover card	Page URL	Modification date	_merge
Region	Release
AE	2001-06-04	1	0	2	1	0	0	0	0	0	1	1	1
	2002-08-08	2	100	87	3	0	0	0	1	2	2	2	1
	2002-10-24	1	144	144	5	0	0	1	1	1	1	1	1
	2003-04-17	1	3	3	1	0	0	0	1	0	1	1	1
	2003-06-26	1	105	105	5	0	0	1	1	1	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
TC	2014-01-29	1	40	40	4	0	2	0	1	1	1	1	1
	2014-05-01	1	20	20	4	0	0	1	1	0	1	1	1
	2015-03-01	2	40	26	1	0	0	0	0	0	2	2	1
	2015-08-29	1	100	100	6	0	0	1	1	1	1	1	1
	2015-12-05	1	100	100	6	0	0	1	1	1	1	1	1

3173 rows × 12 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Region
AE	0	0	1	3	4	3	3	5	2	1	4	1	1	1	1	1	1	0	0	0	0	0	0	0	0
AU	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
DE	0	0	0	0	8	21	22	17	31	27	23	28	31	30	28	30	27	28	20	15	13	10	8	7	1
EN	0	0	2	2	3	16	29	48	50	45	33	45	47	49	42	43	34	35	20	15	13	10	12	11	2
EU	0	0	0	2	2	4	0	0	0	2	0	2	0	0	0	2	2	1	0	0	0	0	0	0	0
FC	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
FR	0	0	0	0	5	20	22	17	31	27	23	27	28	30	29	28	27	28	19	15	13	10	8	7	1
IT	0	0	0	0	5	20	21	17	31	27	23	27	29	30	28	28	27	28	20	15	13	10	8	7	1
JA	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0
JP	18	12	9	11	11	20	24	26	32	40	40	49	46	44	49	43	43	52	14	16	20	14	25	26	10
KR	0	0	0	0	2	8	7	13	20	24	21	21	30	29	29	23	22	21	17	10	12	10	23	26	1
NA	0	0	0	5	16	6	0	2	2	1	2	1	1	0	0	2	3	0	2	0	0	0	0	0	0
PT	0	0	0	0	0	10	6	0	0	0	0	0	0	1	24	24	25	26	18	14	13	9	8	7	1
SC	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4	7	10	2
SP	0	0	0	0	4	20	20	10	24	22	21	27	27	30	28	28	27	28	19	14	13	10	9	7	1
TC	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	4	0	0	0	0	0	0	0	0

By series

		Set	Card number	Name	Rarity	Print	Quantity	Region	Set type	Cover card	Page URL	Modification date	_merge
Series	Release
+1 Bonus Pack	2020-10-31	1	19	19	3	0	0	1	1	0	1	1	1
	2021-02-04	1	20	20	3	0	0	1	1	0	1	1	1
	2021-04-17	1	19	19	3	0	0	1	1	0	1	1	1
	2021-07-17	1	19	19	3	0	0	1	1	0	1	1	1
	2021-07-21	1	19	19	3	0	0	1	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Yu-Gi-Oh! ZEXAL manga promotional cards	2015-09-01	1	1	1	1	0	0	1	1	0	1	1	1
	2015-10-03	1	1	1	1	0	0	1	1	0	1	1	1
	2015-12-18	1	1	1	1	0	0	1	1	0	1	1	1
	2016-03-01	1	1	1	1	0	0	1	1	0	1	1	1
	2016-09-06	1	1	1	1	0	0	1	1	0	1	1	1

888 rows × 12 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Series
+1 Bonus Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	6	4	1
Animation Chronicle	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	0
Astral Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5	8	3	0	0	0	0	0	0	0	0
Attribute Duelist Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	3	4	0
Battle Pack (Rush Duel)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	4	1
Booster (series)	0	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Booster pack	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Champion Pack	0	0	0	0	0	0	0	1	3	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Classic Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1
Collectors Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	2	2	2	2	2	2	0	0	0
Core Booster	6	0	2	6	11	22	17	17	25	13	14	15	14	16	18	16	17	16	12	10	8	6	8	8	1
Deck Build Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	6	0
Deck Mod Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4	9	8	2
Duelist Pack	0	0	0	0	0	0	2	9	9	10	4	6	7	3	3	1	3	5	1	0	0	0	0	0	0
Entry Pack (series)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	4	4	1
Expansion Pack	0	0	0	0	0	0	0	0	0	3	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0
Gold Series (series)	0	0	0	0	0	0	0	0	0	2	0	2	3	2	0	5	2	2	0	0	0	0	0	0	0
Hidden Arsenal (series)	0	0	0	0	0	0	0	0	0	0	1	3	6	3	3	0	0	0	0	0	0	0	0	0	0
Jump Victory Carnival	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0
Legend Duelist (series)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	4	4	1	1	1	0
Legendary Collection (series)	0	0	0	0	0	0	0	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	0
Master Guide promotional cards (series)	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0
Mattel Action Figure promotional cards	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
McDonald's Promotional Cards	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Monster Figure Collection promotional cards	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0
OTS Tournament Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0
Perfect Rulebook promotional cards	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0
Pharaoh Tour promotional cards	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Premium Pack	0	3	1	0	0	3	1	1	1	2	2	2	1	2	2	2	2	0	0	0	0	0	0	0	0
Shonen Jump promotional cards	0	0	0	0	0	0	2	3	4	3	2	7	2	4	4	6	4	6	1	0	0	0	0	0	0
Sneak Peek Participation Cards	0	0	0	0	0	0	4	4	9	8	3	4	4	5	4	4	4	5	5	3	2	1	0	0	0
Star Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	1	2	0	0	0	0	0	0	0	0
Structure Deck R	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	4	1	0	0	0	0	0	0
The Valuable Book promotional cards	1	1	0	2	1	1	1	1	1	1	1	1	1	1	2	1	1	0	1	0	0	0	0	0	0
V Jump August 1999 Special Present	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
V Jump Edition (series)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	1	1	0	0	0	0
V Jump promotional cards	0	0	0	0	0	0	0	0	0	5	7	7	7	8	10	8	11	13	2	0	0	0	0	0	0
Value Box	0	0	0	0	0	0	0	0	0	0	0	0	1	2	4	1	1	0	0	0	0	0	0	0	0
Yu-Gi-Oh! 5D's manga promotional cards	0	0	0	0	0	0	0	0	0	0	0	2	2	3	4	3	3	1	0	0	0	0	0	0	0
Yu-Gi-Oh! Day promotional cards	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	2	1	0	0	0	0	0	0
Yu-Gi-Oh! GX manga promotional cards	0	0	0	0	0	0	0	1	2	3	3	4	3	2	0	0	0	0	0	0	0	0	0	0	0
Yu-Gi-Oh! R promotional cards	0	0	0	0	0	0	1	1	1	1	1	3	0	0	0	0	0	0	0	0	0	0	0	0	0
Yu-Gi-Oh! World Championship prize cards	0	0	0	0	0	1	1	1	1	1	1	1	1	1	1	1	1	1	0	0	0	0	0	0	0
Yu-Gi-Oh! ZEXAL manga promotional cards	0	0	0	0	0	0	0	0	0	0	0	0	0	4	6	6	7	2	0	0	0	0	0	0	0

By set type

		Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Cover card	Page URL	Modification date	_merge
Set type	Release
Beta set	2017-10-04	1	535	106	1	0	2	5	0	0	1	1	1
Binder	2012-09-21	1	3	3	1	2	0	1	0	0	1	1	1
	2015-04-29	1	3	3	1	0	0	1	0	0	1	1	1
Book promotional card	2004-12-18	1	2	2	1	0	0	1	0	0	1	1	1
	2014-04-04	1	1	1	1	0	0	1	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Video games promotional card	2011-04-28	1	7	7	1	0	0	1	0	0	1	1	1
	2011-05-10	1	3	3	1	0	0	1	0	0	1	1	1
	2013-12-05	1	3	3	1	0	0	1	0	0	1	1	1
	2014-06-26	1	15	3	1	0	0	5	0	0	1	1	1
	2016-07-16	1	1	1	1	0	0	1	0	0	1	1	1

1865 rows × 12 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Set type
Beta set	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0
Binder	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0
Book promotional card	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0
Book promotional cards	1	2	0	2	1	2	1	1	1	2	1	1	2	1	3	2	2	1	1	0	0	0	0	0	0
Booster pack	6	7	4	10	15	40	34	36	44	43	35	48	53	54	59	65	56	52	38	28	31	31	52	53	8
Boss Duel Deck	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0
Bundle	0	0	0	0	0	0	0	0	0	0	0	0	1	2	4	1	1	0	0	0	0	0	0	0	0
Collectible tin	0	0	0	1	2	2	2	3	3	7	10	6	5	4	7	2	2	2	2	1	2	1	1	1	0
Collector's Set	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	0	0	3	2	1	4	0
Core Booster	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Deluxe Edition	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	6	0	0	0	0	0	0	0	0	0
Demo Deck	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	2	2	0	3	0	0	0	0	0
Duel Disk	0	0	0	0	0	0	0	1	1	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0
Duel Disk promotional cards	0	0	0	0	0	0	0	1	1	0	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Duel Terminal	0	0	0	0	0	0	0	0	0	6	4	7	6	9	2	0	0	0	0	0	0	0	0	0	0
Duelist League participation cards	0	0	0	0	4	4	2	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Duelist Set	0	0	0	0	0	0	0	0	0	0	0	0	0	3	5	1	0	0	0	0	0	0	0	0	0
Enhancement Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0
Hobby League participation cards	0	0	0	0	0	2	1	13	12	12	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Magazine promotional card	1	0	0	0	0	0	3	3	4	10	10	17	10	13	14	14	15	20	3	0	0	0	0	0	0
Magazine promotional cards	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Main Deck	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
Manga promotional card	0	0	0	1	0	0	1	4	3	4	4	9	5	9	10	9	10	3	0	0	0	0	0	0	0
Participation card	1	0	0	0	0	0	4	4	9	8	4	5	4	5	4	4	4	5	5	3	2	1	0	0	0
Preconstructed Deck	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	1	0	0	4	0
Prize card	0	0	2	0	0	1	1	1	1	1	1	1	2	1	1	1	1	1	0	0	0	0	0	0	0
Prize cards	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0
Promotional card	2	0	2	1	0	1	1	8	8	5	7	14	19	8	5	5	7	17	5	3	6	2	9	11	7
Promotional cards	2	0	1	1	5	7	2	1	0	0	1	4	3	1	3	2	1	0	0	0	1	0	0	0	0
Special Edition	0	0	0	0	2	3	3	7	12	11	13	8	8	12	2	3	7	8	7	4	2	1	0	0	0
Starter Deck	1	1	0	4	13	18	2	0	3	2	5	4	3	4	8	5	7	4	0	0	0	0	2	0	0
Structure Deck	0	0	2	1	3	0	8	10	8	6	7	6	9	9	8	11	13	17	4	0	0	0	0	0	0
Tournament prize card	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Tournament promotional card	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Vendor Edition	0	0	0	0	0	1	2	2	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Video game promotional card	1	2	0	0	0	0	0	0	5	0	3	4	2	0	0	0	0	0	0	0	0	0	0	0	0
Video games promotional card	0	0	0	1	3	8	7	4	8	4	3	0	4	0	1	1	0	1	0	0	0	0	0	0	0

Debug

This section is used for debugging the extraction of data from MediaWiki query responses

Has nan name/number

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
5979	Premium Pack 2	<NA>	Super War-Lion	(Ultra Rare,)	<NA>	<NA>	JP	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Premium_Pack_2	2015-05-22 19:35:08	both
5980	Premium Pack 2	<NA>	Zera the Mant	(Ultra Rare,)	<NA>	<NA>	JP	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Premium_Pack_2	2015-05-22 19:35:08	both
5981	Premium Pack 2	<NA>	Black Luster Soldier	(Ultra Rare,)	<NA>	<NA>	JP	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Premium_Pack_2	2015-05-22 19:35:08	both
5982	Premium Pack 2	<NA>	Fiend's Mirror	(Ultra Rare,)	<NA>	<NA>	JP	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Premium_Pack_2	2015-05-22 19:35:08	both
5983	Premium Pack 2	<NA>	Black Luster Ritual	(Ultra Rare,)	<NA>	<NA>	JP	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Premium_Pack_2	2015-05-22 19:35:08	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
145181	EX Starter Box	<NA>	De-Spell	(Common,)	Reprint	2	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145182	EX Starter Box	<NA>	Castle Walls	(Common,)	Reprint	1	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145183	EX Starter Box	<NA>	Ultimate Offering	(Common,)	Reprint	1	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
156162	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Academia_Disk	2022-12-28 20:46:20	right_only
156163	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Structure_Deck:_Mar...	2014-07-03 18:52:14	right_only

733 rows × 14 columns

Has nan rarity

array(['Dark Revelation Volume 1', 'Advanced Tournament Pack 2013 Vol.3',
       'V Jump April 2013 Tokens', 'Dark Beginning 2',
       'Advanced Event Pack 2013 Vol.2', 'Dark Beginning 1',
       'Dark Revelation Volume 2', 'Advanced Event Pack 2014 Vol.1',
       'Advanced Tournament Pack 2013 Vol.4',
       'The Valuable Book character cards',
       'Advanced Tournament Pack 2016 Vol.1', 'Classic Pack 03',
       'Deck Build Pack: Tactical Masters', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has nan release

array(['Astral Pack Two',
       'Invasion: Vengeance Sneak Peek Participation Card',
       'Premium Pack 2', 'Shonen Jump Vol. 7, Issue 6 promotional card',
       'Yu-Gi-Oh! Power of Chaos: Kaiba the Revenge promotional cards',
       'Structure Deck: Marik',
       'Crossed Souls Sneak Peek Participation Card',
       'Hobby League 6 participation card E',
       'Sneak Peek Participation Cards',
       'Shadow Specters Sneak Peek Participation Card',
       'Shonen Jump Vol. 4, Issue 11 promotional card', 'Astral Pack One',
       'Secrets of Eternity Sneak Peek Participation Card', 'Magic Ruler',
       'Gold Series', 'Spell Ruler',
       'The Lost Millennium: Special Edition',
       'Tournament Pack 2008 Vol.1',
       'Yu-Gi-Oh! GX Volume 4 promotional card', 'Premium Pack',
       "Yu-Gi-Oh! 5D's Wheelie Breakers promotional cards",
       'Ancient Prophecy Sneak Peek Participation Card',
       'Shonen Jump Vol. 10, Issue 3 promotional card',
       'Shonen Jump Vol. 3, Issue 6 promotional card',
       'Yu-Gi-Oh! GX manga promotional cards',
       'Dimension of Chaos Sneak Peek Participation Card',
       'Legacy of the Valiant Sneak Peek Participation Card',
       "Yu-Gi-Oh! 5D's World Championship 2011: Over the Nexus promotional cards",
       'Yu-Gi-Oh! The Official Magazine promotional cards',
       'Hobby League 6 participation card F',
       'Shonen Jump Vol. 9, Issue 4 promotional card',
       "Structure Deck: Dinosaur's Rage Special Edition",
       'Academy Duel Disk', 'Raging Battle Sneak Peek Participation Card',
       'Shonen Jump Vol. 4, Issue 12 promotional card',
       'Yu-Gi-Oh! Championship Series Prize Cards',
       'Duelist League Demo 2010',
       'Shonen Jump Vol. 6, Issue 5 promotional card',
       'Hobby League 6 participation card A',
       'Shonen Jump December 2010 subscription bonus',
       'Tournament Pack 2008 Vol.2', 'Millennium Pack',
       'Shonen Jump Vol. 10, Issue 4 promotional card',
       'Yu-Gi-Oh! R promotional cards',
       'Hobby League participation cards',
       'Shonen Jump Vol. 3, Issue 9 promotional card',
       'Shonen Jump Scholastic Edition Vol. 9, Issue 1 promotional card',
       'Shonen Jump Vol. 7, Issue 9 promotional card',
       'Shonen Jump Vol. 9, Issue 6 promotional card',
       'Hobby League 7 participation card A', 'The Sanctuary in the Sky',
       'Shonen Jump Vol. 5, Issue 1 promotional card',
       'Shonen Jump May 2008 subscription bonus',
       'Shonen Jump Vol. 7, Issue 3 promotional card',
       'Yu-Gi-Oh! Worldwide Edition: Stairway to the Destined Duel promotional cards',
       'Hobby League 6 participation card B',
       'Shonen Jump June/July 2011 subscription bonus',
       'Ancient Sanctuary', 'National Championship 2011',
       'Shonen Jump August 2008 subscription bonus',
       'Tournament Pack 2009 Vol.3',
       'Structure Deck: Machine Re-Volt Special Edition',
       "Structure Deck: Dinosaur's Rage Special Set",
       "Yu-Gi-Oh! 5D's manga promotional cards",
       'Banzai! promotional cards',
       'Shonen Jump Vol. 3, Issue 11 promotional card',
       'Tournament Pack 2009 Vol.4',
       'The New Challengers Sneak Peek Participation Card',
       'Invader of Darkness',
       'Shonen Jump Vol. 9, Issue 8 promotional card',
       'The Valuable Book promotional cards',
       "Yu-Gi-Oh! 5D's Volume 1 promotional card",
       'Hobby League 7 participation card B',
       'Shonen Jump Vol. 5, Issue 6 promotional card',
       'Shonen Jump Vol. 6, Issue 9 promotional card',
       'Hobby League 6 participation card C',
       'Shonen Jump May 2006 subscription bonus',
       'National Championship 2012',
       'Shonen Jump Vol. 6, Issue 1 promotional card',
       'Shadow of Infinity: Special Edition',
       'Shonen Jump May 2010 subscription bonus',
       'Shonen Jump Vol. 4, Issue 2 promotional card', 'Duel Disk',
       'Ultimate Edition',
       'Shonen Jump Vol. 7, Issue 11 promotional card',
       'Hobby League 7 participation card C',
       'Shonen Jump Vol. 9, Issue 10 promotional card',
       'The Valuable Book character cards',
       'Hobby League 6 participation card D',
       'Shonen Jump Championship Series Prize Cards',
       'Shonen Jump Vol. 9, Issue 1 promotional card',
       'National Championship 2013', 'Curse of Anubis',
       'Shonen Jump Vol. 10, Issue 1 promotional card',
       'Hobby League 7 participation card D', '2013 Collectible Tins',
       '20th Anniversary Duel Set', 'Booster Pack Tin Series Promos',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Collectible Tins 2005', 'Collectible Tins 2006',
       'Collectible Tins 2007', 'Collectible Tins 2008',
       'Collectible Tins 2008 Wave 2', 'Collectible Tins 2009',
       'Collectible Tins 2010', 'Collectible Tins 2011',
       'Collectible Tins 2012',
       'Continuous Token Gifts Promotional Cards', 'Demo Pack',
       'Duelist League 18 participation cards',
       'Duelist League Series 1 participation cards',
       'Duelist League Series 2 participation cards',
       'Duelist Pack: Yugi', 'Exclusive Pack', 'Ghosts From the Past',
       'Judge promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Merge failed

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
156162	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Academia_Disk	2022-12-28 20:46:20	right_only
156163	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Structure_Deck:_Mar...	2014-07-03 18:52:14	right_only

8

array(['2013 Collectible Tins Wave 1', 'Astral Pack Two',
       'Champion Pack: Game Six', ...,
       'Jump Festa 2005 promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge

Epilogue

Execution completed 30/01/2023 05:14 UTC

HTML export

Notebook saved to disk